
UPDATE [User]
	SET [User].[Username] = '[' + [ForumUser].[ExternalProvider] + '][' + [ForumUser].[ExternalProviderId] + ']'
	FROM [User] INNER JOIN [ForumUser] ON [ForumUser].[ProviderId] = CONVERT(nvarchar(50), [User].[Id])
	WHERE [ForumUser].[ExternalAccount] = 1;
